if(!database.connected()) database.connect("ORACLE", "2:ORCL", "CUB", "CREEK", "") if (!database.connected()) write("Error: Unable to connect to database.") else

if(client.Name == null) { write("  Log In") } else { write("  Welcome, " + client.Name + " ") } Privacy if(client.totalQuantity == null) { } else { if(client.totalQuantity > 0) { write(" |  View Cart: " + client.totalQuantity + " item(s) " + client.totalDollars + " sub-total ") } else { } }  |  My Account

if(request.Brand == 'All') { } else { }

write("");

client.Brand = escape(request.Brand); client.C1Desc = escape(request.C1Desc); client.C2Desc = escape(request.C2Desc); if(client.Brand == 'All') { cursor = database.cursor("select distinct c3desc from versitex.product where brand like '%' and c1desc like '" + unescape(client.C1Desc) + "' and c2desc like '" + unescape(client.C2Desc) + "' order by c3desc ") cursor.next() if(cursor.c3desc == '*') { cursor1 = database.cursor("select sub from versitex.product where brand like '%' and c1desc like '" + unescape(client.C1Desc) + "' and c2desc like '" + unescape(client.C2Desc) + "' "); cursor1.next(); var sub = 0; sub = cursor1.sub; cursor1.close(); cursor.close(); redirect("product.html?Id=" + sub + " "); } else { write(" Home > All Brands > " + unescape(client.C1Desc) + " > " + unescape(client.C2Desc) + " "); cursor = database.cursor("select distinct c3desc from versitex.product where brand like '%' and c1desc like '" + unescape(client.C1Desc) + "' and c2desc like '" + unescape(client.C2Desc) + "' order by c3desc "); while(cursor.next()) { write(" " + cursor.c3desc + " ") } cursor.close(); write(" "); cursor = database.cursor("select content from versitex.ad where page = 'type3.html' and brand = 'All' and c1 = '" + unescape(client.C1Desc) + "' and c2 = '" + unescape(client.C2Desc) + "' "); cursor.next(); write(" " + cursor.content + " "); cursor.close(); } } else { cursor = database.cursor("select distinct c3desc from versitex.product where brand like '" + unescape(client.Brand) + "' and c1desc like '" + unescape(client.C1Desc) + "' and c2desc like '" + unescape(client.C2Desc) + "' order by c3desc ") cursor.next() if(cursor.c3desc == '*') { cursor1 = database.cursor("select sub from versitex.product where brand like '" + unescape(client.Brand) + "' and c1desc like '" + unescape(client.C1Desc) + "' and c2desc like '" + unescape(client.C2Desc) + "' "); cursor1.next(); var sub = 0; sub = cursor1.sub; cursor1.close(); cursor.close(); redirect("product.html?Id=" + sub + " "); } else { write(" Home > " + unescape(client.Brand) + " > " + unescape(client.C1Desc) + " > " + unescape(client.C2Desc) + " "); cursor = database.cursor("select distinct c3desc from versitex.product where brand like '" + unescape(client.Brand) + "' and c1desc like '" + unescape(client.C1Desc) + "' and c2desc like '" + unescape(client.C2Desc) + "' order by c3desc "); while(cursor.next()) { write(" " + cursor.c3desc + " ") } cursor.close(); write(" "); cursor = database.cursor("select content from versitex.ad where page = 'type3.html' and brand = '" + unescape(client.Brand) + "' and c1 = '" + unescape(client.C1Desc) + "' and c2 = '" + unescape(client.C2Desc) + "' "); cursor.next(); write(" " + cursor.content + " "); cursor.close(); } }

Versitex of America · 3545 Schuylkill Rd., Rte 724 · Spring City, PA 19475-1527 · Phone: 610-948-4442  Fax: 610-948-7310 · About Versitex · ©  Versitex of America · Contact Us